	
	*use "$MAIN\GINI & Urbanization Rate & GDPPC_WDI.dta" 
	import excel "$data/raw/WDI_GDPPC_raw.xlsx", firstrow clear


	* Drop irrelevant variables
	drop Series* CountryCode

	rename CountryName country_gallup
	drop if country==""

	reshape long YR, i(country) j(year)

	ren YR gdppc
	lab var gdppc "GDPPC current US$"
	
	replace gdppc = "" if gdppc == ".."
	destring gdppc, replace
	
	replace country = "Cape Verde" if strpos(country, "Verde") > 0
	replace country = "Congo Brazzaville" 			if country == "Congo, Rep."
	replace country = "Congo Kinshasa" 				if country == "Congo, Dem. Rep."
	replace country = "Hong Kong" if strpos(country, "Hong Kong") > 0
	replace country = "Iran" if strpos(country, "Iran") > 0
	replace country = "South Korea" if country == "Korea, Rep."
	replace country = "Laos" 						if strpos(country, "Lao People's") > 0
	replace country = "Macao SAR" 					if strpos(country, "Macao") > 0
	replace country = "Macedonia, FYR" 				if strpos(country, "Macedonia") > 0
	replace country = "Russia" 						if strpos(country, "Russia") > 0
	replace country = "East Timor" 						if strpos(country, "Timor-Leste") > 0
	replace country = "Turkey" 						if strpos(country, "Turkiye") > 0
	replace country = "Venezuela"					if strpos(country, "Venezuela") > 0

	save "$data/GDPPC_cleaned.dta", replace